{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Form T-102"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form T-102","index":0,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[[11,20,11,23],[12,20,12,23],[8,20,8,23],[9,20,9,23],[10,20,10,23],[41,11,41,17],[42,11,42,17],[43,11,43,17],[45,12,45,16],[28,11,28,12],[28,13,28,14],[28,15,28,16],[23,13,23,14],[21,15,21,16],[22,11,22,12],[22,13,22,14],[22,15,22,16],[23,15,23,16],[9,17,10,17],[29,15,29,16],[20,11,20,12],[20,15,20,16],[19,11,19,12],[19,13,19,14],[50,11,50,16],[49,12,49,16],[42,1,42,7],[42,8,42,10],[43,1,43,7],[52,1,52,10],[44,11,44,12],[49,1,49,7],[50,1,50,7],[48,8,48,10],[48,12,48,16],[51,1,51,7],[51,8,51,10],[44,1,44,10],[45,1,45,10],[46,1,46,7],[46,8,46,10],[47,1,47,7],[49,8,49,10],[50,8,50,10],[48,1,48,7],[46,12,46,16],[47,8,47,10],[41,1,41,7],[41,8,41,10],[43,8,43,10],[47,12,47,16],[44,13,44,16],[36,11,36,12],[32,13,32,14],[34,11,34,12],[32,11,32,12],[40,1,40,16],[39,15,39,16],[35,15,35,16],[37,11,37,12],[36,13,36,14],[37,13,37,14],[36,15,36,16],[37,15,37,16],[33,5,33,6],[26,15,26,16],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[21,13,21,14],[22,7,22,8],[22,9,22,10],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,14],[25,7,25,8],[3,10,3,17],[3,4,3,9],[3,1,3,3],[6,4,6,9],[6,1,6,3],[6,10,6,17],[4,10,4,17],[4,4,4,9],[12,15,12,16],[12,9,12,10],[10,11,10,12],[10,13,10,14],[10,9,10,10],[8,2,8,17],[12,11,12,12],[12,13,12,14],[10,3,10,4],[11,1,11,2],[12,1,12,2],[11,3,11,4],[10,5,10,6],[10,7,10,8],[11,5,11,6],[11,7,11,8],[10,15,10,16],[11,9,11,10],[11,11,11,12],[11,13,11,14],[11,15,11,16],[13,1,13,2],[30,1,30,2],[17,1,17,2],[21,1,21,2],[15,1,15,2],[24,1,24,2],[25,1,25,2],[25,3,25,4],[22,1,22,2],[16,1,16,2],[26,3,26,4],[18,3,18,4],[18,1,18,2],[18,5,18,6],[14,15,14,16],[12,3,12,4],[13,3,13,4],[16,3,16,4],[13,5,13,6],[19,7,19,8],[32,15,32,16],[33,15,33,16],[32,9,32,10],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[17,3,17,16],[18,11,18,12],[18,13,18,14],[18,15,18,16],[19,3,19,4],[24,15,24,16],[23,7,23,8],[23,9,23,10],[23,11,23,12],[21,11,21,12],[34,15,34,16],[32,5,32,6],[15,3,15,4],[12,5,12,6],[13,7,13,8],[15,7,15,8],[13,13,13,14],[13,15,13,16],[13,9,13,10],[13,11,13,12],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[12,7,12,8],[19,9,19,10],[20,9,20,10],[20,7,20,8],[21,9,21,10],[21,7,21,8],[19,15,19,16],[20,13,20,14],[19,5,19,6],[33,11,33,12],[34,3,34,4],[16,5,16,6],[16,13,16,14],[15,5,15,6],[16,11,16,12],[38,1,38,2],[38,3,38,4],[38,5,38,6],[38,7,38,8],[37,1,37,2],[36,3,36,4],[37,3,37,4],[36,5,36,6],[37,5,37,6],[36,7,36,8],[36,1,36,2],[35,7,35,8],[35,5,35,6],[30,3,30,16],[37,7,37,8],[37,9,37,10],[36,9,36,10],[38,9,38,10],[38,11,38,12],[38,13,38,14],[38,15,38,16],[20,1,20,2],[23,1,23,2],[26,1,26,2],[9,11,9,12],[9,13,9,14],[9,15,9,16],[34,9,34,10],[21,3,21,4],[20,5,20,6],[24,3,24,4],[23,5,23,6],[22,3,22,4],[22,5,22,6],[21,5,21,6],[25,5,25,6],[23,3,23,4],[9,1,9,2],[14,3,14,4],[14,5,14,6],[35,3,35,4],[33,1,33,2],[35,11,35,12],[35,13,35,14],[7,4,7,9],[9,7,9,8],[9,9,9,10],[29,1,29,2],[35,9,35,10],[33,13,33,14],[34,13,34,14],[31,11,31,12],[19,1,19,2],[20,3,20,4],[9,3,9,4],[14,1,14,2],[10,1,10,2],[28,1,28,2],[35,1,35,2],[7,11,7,13],[9,5,9,6],[27,1,27,17],[18,7,18,8],[18,9,18,10],[32,1,32,2],[32,3,32,4],[32,7,32,8],[34,1,34,2],[33,7,33,8],[34,5,34,6],[34,7,34,8],[33,9,33,10],[1,1,1,17],[4,1,4,3],[7,1,7,3],[29,11,29,12],[31,1,31,2],[31,3,31,6],[31,7,31,10],[31,13,31,14],[31,15,31,16],[29,13,29,14],[2,1,2,17],[16,15,16,16],[16,7,16,8],[14,7,14,8],[7,15,7,17],[14,13,14,14],[14,9,14,10],[14,11,14,12],[16,9,16,10]]}
[]
[null,"T-102"]
[null,"IMPORTANT:  Attach all receipts and/ or invoices applicable to this report."]
[null,"Date of this report:",null,null,"Budget Acct No.:",null,null,null,null,null,"Department:"]
[]
[]
[null,"Employee Name:",null,null,"Title:",null,null,null,null,null,"Travel Dates: (mm/dd/yyyy)"]
[null,null,null,null,null,null,null,null,null,null,"From:",null,null,null,"To:"]
[null,"Purpose of Travel"]
[null,"Day",null,"Sun",null,"Mon",null,"Tues",null,"Wed",null,"Thurs",null,"Fri",null,"Sat",null,"TOTALS"]
[null,"Enter dates (mm/dd/yyyy) >>>"]
[null,"Transportation"]
[null,"Air",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D13:Q13)=0, \"\", SUM(D13:Q13))","v":""}]
[null,"Taxi/Bus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D14:Q14)=0, \"\", SUM(D14:Q14))","v":""}]
[null,"Rental Vehicle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D15:Q15)=0, \"\", SUM(D15:Q15))","v":""}]
[null,"Accommodations"]
[null,"Lodging (Attach if Per Diem is Waived)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D17:Q17)=0, \"\", SUM(D17:Q17))","v":""}]
[null,"Meals",null,"**************************DO NOT USE 75% PER DIEM RATE FOR ANY MEALS****************************************************"]
[null,"Per Diem (www.gsa.gov)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D19:Q19)=0, \"\", SUM(D19:Q19))","v":""}]
[null,"Breakfast (20%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D20:Q20)=0, \"\", SUM(D20:Q20))","v":""}]
[null,"Lunch (30%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Dinner (50%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Fees/ Misc. Expenses"]
[null,"Registration Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Parking",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Telephone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Other(Explain below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,"Daily Totals",null,{"$f":"IF(SUM(D13:E27)=0, \"\", SUM(D13:E27))","v":""},{"$f":"IF(SUM(#REF!)=0, \"\", SUM(#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(SUM(F13:G27)=0, \"\", SUM(F13:G27))","v":""},{"$error":"#REF!"},{"$f":"IF(SUM(H13:I27)=0, \"\", SUM(H13:I27))","v":""},{"$error":"#REF!"},{"$f":"IF(SUM(J13:K27)=0, \"\", SUM(J13:K27))","v":""},{"$error":"#REF!"},{"$f":"IF(SUM(L13:M27)=0, \"\", SUM(L13:M27))","v":""},{"$error":"#REF!"},{"$f":"IF(SUM(N13:O27)=0, \"\", SUM(N13:O27))","v":""},{"$error":"#REF!"},{"$f":"IF(SUM(P13:Q27)=0, \"\", SUM(P13:Q27))","v":""},{"$error":"#REF!"},{"$f":"IF(SUM(R13:R27)=0, \"\", SUM(R13:R27))","v":""}]
[]
[null,"Mileage – Personal Auto ",null,"****Use shortest distance per MapQuest to calculate mileage if not providing Odometer Readings and attach copy****  "]
[null,null,null,null,null,null,null,"Odometer Reading",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D32:Q33)=0, \"\", SUM(D32:Q33))","v":""}]
[null,"From",null,"To",null,"Date of Travel",null,"Begin",null,"End",null,"Mileage****",null,"Rate",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,{"$f":"L34*N34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.67,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mileage Total",null,{"$f":"SUM(P34:Q39)","v":0}]
[null,"TOTALS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R29,R40)=0, \"\", SUM(R29,R40))","v":""}]
[]
[]
[null,"Employee Signature",null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Expenses",null,null,null,null,null,{"$f":"R41","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Less:","Registration Fees paid in advance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenses charged on City card"]
[null,"Department Head or City Manager Signature for Approval",null,null,null,null,null,null,"Date",null,null,null,"Disallowed Expenses if any"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cash Advance (if any)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Deductions",null,null,null,null,{"$f":"IF(SUM(R46:R49)=0, \"\", SUM(R46:R49))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Balance Due to City or Employee",null,null,null,null,null,{"$f":"IF((SUM(D13:Q27)+SUM(P34:Q39))-SUM(R46:R49)=0,\"\",(SUM(D13:Q27)+SUM(P34:Q39))-SUM(R46:R49))","v":""}]
[null,"Finance Director Signature for Approval",null,null,null,null,null,null,"Date"]